-
Re: Counting Blank Cells
If your cells are blank, then this should work: =COUNTIF({Status Blank}, "") However, this will also capture any blank rows (such as those at the bottom of your sheet, so I would use an alt…2 · -
Re: Can you combine approval requests from multiple rows in one email?
Hi @JonathanT, It is - you just need to do one of two things: 1. Change the automation away from being "When triggered": More information on this here: Alerts & Reminders | Smartsheet L…1 · -
Re: Nested IF Fomula help
Hi @Kpennington, You have some brackets closing some of your IFs which should be moved to the end: =IF(ISBLANK([Contractor Name]@row), "No", IF(OR([Contractor Name]@row = "NA"), &…1 · -
Re: COUNTIF AND for data in 2 columns
Unfortunately you can't reference the header in the formula, but you would use a COUNTIFS in combination with some cross sheet references. So for your first column (PSER.122): =COUNTIFS({Device Type}…1 · -
Re: COUNTIF functions returning 0
Hi @roxxtheboxx, Amend your formula slightly: =COUNTIFS({Dump: OPEN AND CLOSED REQS Range 1}, VALUE(@cell)=1, {Dump: OPEN AND CLOSED REQS Range 2}, "Open") This should fix the issue for you…1 ·